-: In this lecture, we are talking
about a waterfall chart within PowerPoint.
A waterfall chart is made of total values,
positive and negative change.
It tells the story how this value
came to the last value.
For Windows, this chart, I believe was added in 2016.
I'm looking at the official support page of Microsoft
and I think this isn't available on the Mac version.
On the Mac version, it says here,
Excel for Microsoft 365 but not PowerPoint
for Microsoft 365.
If you are on a Mac, probably at this point,
the waterfall chart won't be available to you.
Hopefully I'm wrong or at least in future versions
Microsoft will include it.
This is why I'm treating this more as a bonus lecture.
A waterfall chart, let me take the data.
Here I have like increase and decrease
of a certain sales in a given month.
We have mirror sales for January.
I'll take this entire table.
I will add a waterfall chart
and count revenue and total revenue.
Let me insert the chart.
It will be a waterfall chart
but by default, this is what we get.
We have a waterfall chart with one, two, three total values.
I'll explain total values in a second.
I'll place the data
and what I have to do here,
I have to count the increase and decrease.
So I'll put this aside a little lower.
So this would be revenue.
And here I will just make equal sign sum
and summarize the balance, the January sales
and the add-ons or maybe not.
Maybe, okay, yeah, all three of them.
This is the sum.
And then total revenue.
Now I wanna count everything together.
By counting everything together, I mean the revenue.
Oh, sorry.
Equal sign sum.
I need to open the function.
The revenue but we had some costs for shipping,
for stress testing, for warranties
and I'll close that down.
So this will be the last total value you have.
You can see PowerPoint automatically
has set its total value here.
Let me Control + B the first step.
Number two, set the revenue as total.
We have revenue here.
I need to click on this particular bar.
Click on it again. Right click.
And set as total.
This is a function unique to the waterfall chart.
Available only here.
Okay, but this shouldn't be a total value.
I'll click on this.
Right click, clear total
because this wasn't a total at all.
This was just default by PowerPoint.
Okay, now set colors.
Increase should be green
and decrease should be red.
It is much easier to see increase
if it is color coded.
By color coded, I mean something
that people recognize instantly.
By green, this is the universal color for growth.
And for the decrease, the universal color would be,
of course, red.
Now this chart is much easier to understand
because here we have some increase, decrease
and this will be the end value.
Make y-axis, or data labels, display currency in dollars.
Here on the left side, we have like a value
but a value of what?
This is actually in thousands of dollars
or we have the entire value here
but I can write click, format axis.
Just like in other charts, we have the display units here.
So I'll display thousands.
Okay, it is a number.
Now I need to open the number
and press space and add a dollar sign.
I'll press Add and what happens now?
Right now we see $80, $100
but if we go show display units label on chart,
this will be in thousands of dollars.
If you don't want to set it like that,
if you want the entire dollar value, no problem.
Just deselect that.
Select none and it would be the entire value shown.
I just added the little dollar sign at the end
so it's easier to understand.
We should actually do this to our data labels.
So you can do the same with the data labels number.
You can add a dollar sign, not percentage, dollar.
Press Add at the end.
Okay, make y-axis, or data labels, display currencies.
We did that.
Number five, PowerPoint, you can't move things around here.
Now, the waterfall chart is a very specific chart.
It always wants to have the title
and items to be on the middle.
You can see I cannot move this.
I cannot move the legend.
Well, we don't really need the legend.
So it's a very specific type of chart.
Also, if I select it,
and I wanna add an item inside of it,
you can see it's not adding to the waterfall chart.
So as you can see, the waterfall chart is very specific.
If you don't have this feature,
you would need to count the entire value.
Then subtract the change in value.
So for example, here we would have 74,000.
And here we would have 30,000.
And you should need a stacked bar chart.
A stacked chart would allow me
to make this bottom area, click on this bottom area,
on this bottom chart and make it simply invisible.
We would need to count everything,
so it would be a lot more work.
So this is why it's convenient if this feature
will be finally natively available for everyone.
Thank you for watching.
Treat this as a bonus lecture
and in the next lecture,
I'm gonna show you other cool tricks within PowerPoint.